﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ExternalPractitionerDataSet" targetNamespace="http://tempuri.org/ExternalPractitionerDataSet.xsd" xmlns:mstns="http://tempuri.org/ExternalPractitionerDataSet.xsd" xmlns="http://tempuri.org/ExternalPractitionerDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RISConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RISConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ViewLayer.Properties.Settings.GlobalReference.Default.RISConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ExternalPractitioner_TableAdapter" GeneratorDataComponentClassName="ExternalPractitioner_TableAdapter" Name="ExternalPractitioner_" UserDataComponentName="ExternalPractitioner_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.ExternalPractitioner_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[ExternalPractitioner_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([FamilyName_] = @Original_FamilyName_) AND ([GivenName_] = @Original_GivenName_) AND ((@IsNull_MiddleName_ = 1 AND [MiddleName_] IS NULL) OR ([MiddleName_] = @Original_MiddleName_)) AND ((@IsNull_Prefix_ = 1 AND [Prefix_] IS NULL) OR ([Prefix_] = @Original_Prefix_)) AND ((@IsNull_Suffix_ = 1 AND [Suffix_] IS NULL) OR ([Suffix_] = @Original_Suffix_)) AND ((@IsNull_Degree_ = 1 AND [Degree_] IS NULL) OR ([Degree_] = @Original_Degree_)) AND ((@IsNull_LicenseNumber_ = 1 AND [LicenseNumber_] IS NULL) OR ([LicenseNumber_] = @Original_LicenseNumber_)) AND ((@IsNull_BillingNumber_ = 1 AND [BillingNumber_] IS NULL) OR ([BillingNumber_] = @Original_BillingNumber_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LicenseNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BillingNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[ExternalPractitioner_] ([OID_], [Version_], [FamilyName_], [GivenName_], [MiddleName_], [Prefix_], [Suffix_], [Degree_], [LicenseNumber_], [BillingNumber_], [Deactivated_]) VALUES (@OID_, @Version_, @FamilyName_, @GivenName_, @MiddleName_, @Prefix_, @Suffix_, @Degree_, @LicenseNumber_, @BillingNumber_, @Deactivated_);
SELECT OID_, Version_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, LicenseNumber_, BillingNumber_, Deactivated_ FROM ExternalPractitioner_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OID_, Version_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, LicenseNumber_, BillingNumber_, Deactivated_ FROM dbo.ExternalPractitioner_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[ExternalPractitioner_] SET [OID_] = @OID_, [Version_] = @Version_, [FamilyName_] = @FamilyName_, [GivenName_] = @GivenName_, [MiddleName_] = @MiddleName_, [Prefix_] = @Prefix_, [Suffix_] = @Suffix_, [Degree_] = @Degree_, [LicenseNumber_] = @LicenseNumber_, [BillingNumber_] = @BillingNumber_, [Deactivated_] = @Deactivated_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([FamilyName_] = @Original_FamilyName_) AND ([GivenName_] = @Original_GivenName_) AND ((@IsNull_MiddleName_ = 1 AND [MiddleName_] IS NULL) OR ([MiddleName_] = @Original_MiddleName_)) AND ((@IsNull_Prefix_ = 1 AND [Prefix_] IS NULL) OR ([Prefix_] = @Original_Prefix_)) AND ((@IsNull_Suffix_ = 1 AND [Suffix_] IS NULL) OR ([Suffix_] = @Original_Suffix_)) AND ((@IsNull_Degree_ = 1 AND [Degree_] IS NULL) OR ([Degree_] = @Original_Degree_)) AND ((@IsNull_LicenseNumber_ = 1 AND [LicenseNumber_] IS NULL) OR ([LicenseNumber_] = @Original_LicenseNumber_)) AND ((@IsNull_BillingNumber_ = 1 AND [BillingNumber_] IS NULL) OR ([BillingNumber_] = @Original_BillingNumber_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT OID_, Version_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, LicenseNumber_, BillingNumber_, Deactivated_ FROM ExternalPractitioner_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LicenseNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BillingNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="FamilyName_" DataSetColumn="FamilyName_" />
              <Mapping SourceColumn="GivenName_" DataSetColumn="GivenName_" />
              <Mapping SourceColumn="MiddleName_" DataSetColumn="MiddleName_" />
              <Mapping SourceColumn="Prefix_" DataSetColumn="Prefix_" />
              <Mapping SourceColumn="Suffix_" DataSetColumn="Suffix_" />
              <Mapping SourceColumn="Degree_" DataSetColumn="Degree_" />
              <Mapping SourceColumn="LicenseNumber_" DataSetColumn="LicenseNumber_" />
              <Mapping SourceColumn="BillingNumber_" DataSetColumn="BillingNumber_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NoteSeverityEnum_TableAdapter" GeneratorDataComponentClassName="NoteSeverityEnum_TableAdapter" Name="NoteSeverityEnum_" UserDataComponentName="NoteSeverityEnum_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.NoteSeverityEnum_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[NoteSeverityEnum_] WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[NoteSeverityEnum_] ([Code_], [Value_], [Description_], [DisplayOrder_], [Deactivated_]) VALUES (@Code_, @Value_, @Description_, @DisplayOrder_, @Deactivated_);
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM NoteSeverityEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM dbo.NoteSeverityEnum_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[NoteSeverityEnum_] SET [Code_] = @Code_, [Value_] = @Value_, [Description_] = @Description_, [DisplayOrder_] = @DisplayOrder_, [Deactivated_] = @Deactivated_ WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM NoteSeverityEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code_" DataSetColumn="Code_" />
              <Mapping SourceColumn="Value_" DataSetColumn="Value_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="DisplayOrder_" DataSetColumn="DisplayOrder_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Staff_TableAdapter" GeneratorDataComponentClassName="Staff_TableAdapter" Name="Staff_" UserDataComponentName="Staff_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.Staff_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Staff_] WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([Id_] = @Original_Id_) AND ([FamilyName_] = @Original_FamilyName_) AND ([GivenName_] = @Original_GivenName_) AND ((@IsNull_MiddleName_ = 1 AND [MiddleName_] IS NULL) OR ([MiddleName_] = @Original_MiddleName_)) AND ((@IsNull_Prefix_ = 1 AND [Prefix_] IS NULL) OR ([Prefix_] = @Original_Prefix_)) AND ((@IsNull_Suffix_ = 1 AND [Suffix_] IS NULL) OR ([Suffix_] = @Original_Suffix_)) AND ((@IsNull_Degree_ = 1 AND [Degree_] IS NULL) OR ([Degree_] = @Original_Degree_)) AND ([Sex_] = @Original_Sex_) AND ((@IsNull_Title_ = 1 AND [Title_] IS NULL) OR ([Title_] = @Original_Title_)) AND ((@IsNull_LicenseNumber_ = 1 AND [LicenseNumber_] IS NULL) OR ([LicenseNumber_] = @Original_LicenseNumber_)) AND ((@IsNull_BillingNumber_ = 1 AND [BillingNumber_] IS NULL) OR ([BillingNumber_] = @Original_BillingNumber_)) AND ((@IsNull_Type_ = 1 AND [Type_] IS NULL) OR ([Type_] = @Original_Type_)) AND ((@IsNull_UserName_ = 1 AND [UserName_] IS NULL) OR ([UserName_] = @Original_UserName_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Id_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Id_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LicenseNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BillingNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Staff_] ([OID_], [Version_], [Id_], [FamilyName_], [GivenName_], [MiddleName_], [Prefix_], [Suffix_], [Degree_], [Sex_], [Title_], [LicenseNumber_], [BillingNumber_], [Type_], [UserName_], [Deactivated_]) VALUES (@OID_, @Version_, @Id_, @FamilyName_, @GivenName_, @MiddleName_, @Prefix_, @Suffix_, @Degree_, @Sex_, @Title_, @LicenseNumber_, @BillingNumber_, @Type_, @UserName_, @Deactivated_);
SELECT OID_, Version_, Id_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, Sex_, Title_, LicenseNumber_, BillingNumber_, Type_, UserName_, Deactivated_, FamilyName_ + ' ' + GivenName_ AS FullName FROM Staff_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Id_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Id_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT OID_, Version_, Id_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, Sex_, Title_, LicenseNumber_, BillingNumber_, Type_, UserName_, Deactivated_, FamilyName_+' '+GivenName_ AS FullName    FROM dbo.Staff_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Staff_] SET [OID_] = @OID_, [Version_] = @Version_, [Id_] = @Id_, [FamilyName_] = @FamilyName_, [GivenName_] = @GivenName_, [MiddleName_] = @MiddleName_, [Prefix_] = @Prefix_, [Suffix_] = @Suffix_, [Degree_] = @Degree_, [Sex_] = @Sex_, [Title_] = @Title_, [LicenseNumber_] = @LicenseNumber_, [BillingNumber_] = @BillingNumber_, [Type_] = @Type_, [UserName_] = @UserName_, [Deactivated_] = @Deactivated_ WHERE (([OID_] = @Original_OID_) AND ([Version_] = @Original_Version_) AND ([Id_] = @Original_Id_) AND ([FamilyName_] = @Original_FamilyName_) AND ([GivenName_] = @Original_GivenName_) AND ((@IsNull_MiddleName_ = 1 AND [MiddleName_] IS NULL) OR ([MiddleName_] = @Original_MiddleName_)) AND ((@IsNull_Prefix_ = 1 AND [Prefix_] IS NULL) OR ([Prefix_] = @Original_Prefix_)) AND ((@IsNull_Suffix_ = 1 AND [Suffix_] IS NULL) OR ([Suffix_] = @Original_Suffix_)) AND ((@IsNull_Degree_ = 1 AND [Degree_] IS NULL) OR ([Degree_] = @Original_Degree_)) AND ([Sex_] = @Original_Sex_) AND ((@IsNull_Title_ = 1 AND [Title_] IS NULL) OR ([Title_] = @Original_Title_)) AND ((@IsNull_LicenseNumber_ = 1 AND [LicenseNumber_] IS NULL) OR ([LicenseNumber_] = @Original_LicenseNumber_)) AND ((@IsNull_BillingNumber_ = 1 AND [BillingNumber_] IS NULL) OR ([BillingNumber_] = @Original_BillingNumber_)) AND ((@IsNull_Type_ = 1 AND [Type_] IS NULL) OR ([Type_] = @Original_Type_)) AND ((@IsNull_UserName_ = 1 AND [UserName_] IS NULL) OR ([UserName_] = @Original_UserName_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT OID_, Version_, Id_, FamilyName_, GivenName_, MiddleName_, Prefix_, Suffix_, Degree_, Sex_, Title_, LicenseNumber_, BillingNumber_, Type_, UserName_, Deactivated_, FamilyName_ + ' ' + GivenName_ AS FullName FROM Staff_ WHERE (OID_ = @OID_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Id_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Id_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_OID_" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Version_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Version_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Id_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Id_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_FamilyName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FamilyName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GivenName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GivenName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MiddleName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MiddleName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MiddleName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prefix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Prefix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Prefix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Suffix_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Suffix_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Suffix_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Sex_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Sex_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LicenseNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LicenseNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LicenseNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BillingNumber_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BillingNumber_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BillingNumber_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Type_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Type_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserName_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserName_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="Id_" DataSetColumn="Id_" />
              <Mapping SourceColumn="FamilyName_" DataSetColumn="FamilyName_" />
              <Mapping SourceColumn="GivenName_" DataSetColumn="GivenName_" />
              <Mapping SourceColumn="MiddleName_" DataSetColumn="MiddleName_" />
              <Mapping SourceColumn="Prefix_" DataSetColumn="Prefix_" />
              <Mapping SourceColumn="Suffix_" DataSetColumn="Suffix_" />
              <Mapping SourceColumn="Degree_" DataSetColumn="Degree_" />
              <Mapping SourceColumn="Sex_" DataSetColumn="Sex_" />
              <Mapping SourceColumn="Title_" DataSetColumn="Title_" />
              <Mapping SourceColumn="LicenseNumber_" DataSetColumn="LicenseNumber_" />
              <Mapping SourceColumn="BillingNumber_" DataSetColumn="BillingNumber_" />
              <Mapping SourceColumn="Type_" DataSetColumn="Type_" />
              <Mapping SourceColumn="UserName_" DataSetColumn="UserName_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ExternalPractitionerDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ExternalPractitionerDataSet" msprop:Generator_UserDSName="ExternalPractitionerDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ExternalPractitioner_" msprop:Generator_TableClassName="ExternalPractitioner_DataTable" msprop:Generator_TableVarName="tableExternalPractitioner_" msprop:Generator_TablePropName="ExternalPractitioner_" msprop:Generator_RowDeletingName="ExternalPractitioner_RowDeleting" msprop:Generator_UserTableName="ExternalPractitioner_" msprop:Generator_RowChangingName="ExternalPractitioner_RowChanging" msprop:Generator_RowEvHandlerName="ExternalPractitioner_RowChangeEventHandler" msprop:Generator_RowDeletedName="ExternalPractitioner_RowDeleted" msprop:Generator_RowEvArgName="ExternalPractitioner_RowChangeEvent" msprop:Generator_RowChangedName="ExternalPractitioner_RowChanged" msprop:Generator_RowClassName="ExternalPractitioner_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="FamilyName_" msprop:Generator_ColumnVarNameInTable="columnFamilyName_" msprop:Generator_ColumnPropNameInRow="FamilyName_" msprop:Generator_ColumnPropNameInTable="FamilyName_Column" msprop:Generator_UserColumnName="FamilyName_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GivenName_" msprop:Generator_ColumnVarNameInTable="columnGivenName_" msprop:Generator_ColumnPropNameInRow="GivenName_" msprop:Generator_ColumnPropNameInTable="GivenName_Column" msprop:Generator_UserColumnName="GivenName_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName_" msprop:Generator_ColumnVarNameInTable="columnMiddleName_" msprop:Generator_ColumnPropNameInRow="MiddleName_" msprop:Generator_ColumnPropNameInTable="MiddleName_Column" msprop:Generator_UserColumnName="MiddleName_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prefix_" msprop:Generator_ColumnVarNameInTable="columnPrefix_" msprop:Generator_ColumnPropNameInRow="Prefix_" msprop:Generator_ColumnPropNameInTable="Prefix_Column" msprop:Generator_UserColumnName="Prefix_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Suffix_" msprop:Generator_ColumnVarNameInTable="columnSuffix_" msprop:Generator_ColumnPropNameInRow="Suffix_" msprop:Generator_ColumnPropNameInTable="Suffix_Column" msprop:Generator_UserColumnName="Suffix_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Degree_" msprop:Generator_ColumnVarNameInTable="columnDegree_" msprop:Generator_ColumnPropNameInRow="Degree_" msprop:Generator_ColumnPropNameInTable="Degree_Column" msprop:Generator_UserColumnName="Degree_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicenseNumber_" msprop:Generator_ColumnVarNameInTable="columnLicenseNumber_" msprop:Generator_ColumnPropNameInRow="LicenseNumber_" msprop:Generator_ColumnPropNameInTable="LicenseNumber_Column" msprop:Generator_UserColumnName="LicenseNumber_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingNumber_" msprop:Generator_ColumnVarNameInTable="columnBillingNumber_" msprop:Generator_ColumnPropNameInRow="BillingNumber_" msprop:Generator_ColumnPropNameInTable="BillingNumber_Column" msprop:Generator_UserColumnName="BillingNumber_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NoteSeverityEnum_" msprop:Generator_TableClassName="NoteSeverityEnum_DataTable" msprop:Generator_TableVarName="tableNoteSeverityEnum_" msprop:Generator_TablePropName="NoteSeverityEnum_" msprop:Generator_RowDeletingName="NoteSeverityEnum_RowDeleting" msprop:Generator_UserTableName="NoteSeverityEnum_" msprop:Generator_RowChangingName="NoteSeverityEnum_RowChanging" msprop:Generator_RowEvHandlerName="NoteSeverityEnum_RowChangeEventHandler" msprop:Generator_RowDeletedName="NoteSeverityEnum_RowDeleted" msprop:Generator_RowEvArgName="NoteSeverityEnum_RowChangeEvent" msprop:Generator_RowChangedName="NoteSeverityEnum_RowChanged" msprop:Generator_RowClassName="NoteSeverityEnum_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code_" msprop:Generator_ColumnVarNameInTable="columnCode_" msprop:Generator_ColumnPropNameInRow="Code_" msprop:Generator_ColumnPropNameInTable="Code_Column" msprop:Generator_UserColumnName="Code_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value_" msprop:Generator_ColumnVarNameInTable="columnValue_" msprop:Generator_ColumnPropNameInRow="Value_" msprop:Generator_ColumnPropNameInTable="Value_Column" msprop:Generator_UserColumnName="Value_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder_" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder_" msprop:Generator_ColumnPropNameInRow="DisplayOrder_" msprop:Generator_ColumnPropNameInTable="DisplayOrder_Column" msprop:Generator_UserColumnName="DisplayOrder_" type="xs:float" minOccurs="0" />
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Staff_" msprop:Generator_TableClassName="Staff_DataTable" msprop:Generator_TableVarName="tableStaff_" msprop:Generator_TablePropName="Staff_" msprop:Generator_RowDeletingName="Staff_RowDeleting" msprop:Generator_UserTableName="Staff_" msprop:Generator_RowChangingName="Staff_RowChanging" msprop:Generator_RowEvHandlerName="Staff_RowChangeEventHandler" msprop:Generator_RowDeletedName="Staff_RowDeleted" msprop:Generator_RowEvArgName="Staff_RowChangeEvent" msprop:Generator_RowChangedName="Staff_RowChanged" msprop:Generator_RowClassName="Staff_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="Id_" msprop:Generator_ColumnVarNameInTable="columnId_" msprop:Generator_ColumnPropNameInRow="Id_" msprop:Generator_ColumnPropNameInTable="Id_Column" msprop:Generator_UserColumnName="Id_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FamilyName_" msprop:Generator_ColumnVarNameInTable="columnFamilyName_" msprop:Generator_ColumnPropNameInRow="FamilyName_" msprop:Generator_ColumnPropNameInTable="FamilyName_Column" msprop:Generator_UserColumnName="FamilyName_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GivenName_" msprop:Generator_ColumnVarNameInTable="columnGivenName_" msprop:Generator_ColumnPropNameInRow="GivenName_" msprop:Generator_ColumnPropNameInTable="GivenName_Column" msprop:Generator_UserColumnName="GivenName_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MiddleName_" msprop:Generator_ColumnVarNameInTable="columnMiddleName_" msprop:Generator_ColumnPropNameInRow="MiddleName_" msprop:Generator_ColumnPropNameInTable="MiddleName_Column" msprop:Generator_UserColumnName="MiddleName_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="40" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prefix_" msprop:Generator_ColumnVarNameInTable="columnPrefix_" msprop:Generator_ColumnPropNameInRow="Prefix_" msprop:Generator_ColumnPropNameInTable="Prefix_Column" msprop:Generator_UserColumnName="Prefix_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Suffix_" msprop:Generator_ColumnVarNameInTable="columnSuffix_" msprop:Generator_ColumnPropNameInRow="Suffix_" msprop:Generator_ColumnPropNameInTable="Suffix_Column" msprop:Generator_UserColumnName="Suffix_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Degree_" msprop:Generator_ColumnVarNameInTable="columnDegree_" msprop:Generator_ColumnPropNameInRow="Degree_" msprop:Generator_ColumnPropNameInTable="Degree_Column" msprop:Generator_UserColumnName="Degree_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sex_" msprop:Generator_ColumnVarNameInTable="columnSex_" msprop:Generator_ColumnPropNameInRow="Sex_" msprop:Generator_ColumnPropNameInTable="Sex_Column" msprop:Generator_UserColumnName="Sex_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title_" msprop:Generator_ColumnVarNameInTable="columnTitle_" msprop:Generator_ColumnPropNameInRow="Title_" msprop:Generator_ColumnPropNameInTable="Title_Column" msprop:Generator_UserColumnName="Title_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicenseNumber_" msprop:Generator_ColumnVarNameInTable="columnLicenseNumber_" msprop:Generator_ColumnPropNameInRow="LicenseNumber_" msprop:Generator_ColumnPropNameInTable="LicenseNumber_Column" msprop:Generator_UserColumnName="LicenseNumber_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingNumber_" msprop:Generator_ColumnVarNameInTable="columnBillingNumber_" msprop:Generator_ColumnPropNameInRow="BillingNumber_" msprop:Generator_ColumnPropNameInTable="BillingNumber_Column" msprop:Generator_UserColumnName="BillingNumber_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type_" msprop:Generator_ColumnVarNameInTable="columnType_" msprop:Generator_ColumnPropNameInRow="Type_" msprop:Generator_ColumnPropNameInTable="Type_Column" msprop:Generator_UserColumnName="Type_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName_" msprop:Generator_ColumnVarNameInTable="columnUserName_" msprop:Generator_ColumnPropNameInRow="UserName_" msprop:Generator_ColumnPropNameInTable="UserName_Column" msprop:Generator_UserColumnName="UserName_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
              <xs:element name="FullName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="81" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ExternalPractitioner_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="NoteSeverityEnum__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NoteSeverityEnum_" />
      <xs:field xpath="mstns:Code_" />
    </xs:unique>
    <xs:unique name="Staff__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Staff_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
  </xs:element>
</xs:schema>